SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 76380 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 76380 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626019,1041490,296692,232498,877551,114385,204135,969804,623995,190713,980044,418076,784136,334922,664276,525819,419098,665257,1036465,377329,738652,913099,505966,673935,587197,945915,915179,332922,749712,42055,229225,274276,108389,172970,50481,868329,578853,394416,671533,352202,803716,925888,803865,146537,847822,855773,180169,297476,270315,936310,867690,936350,920811,756365,45175,386725,210492,951441,59521,1026048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 76380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 76380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]