SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441471 LIMIT 1 [ RunTime:0.001371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441471 [ RunTime:0.005434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83013,634973,667393,114650,1014195,105887,1015685,1020054,1037730,300366,544732,156767,283347,341098,832644,850387,677841,661306,15875,471399,224585,419636,558590,41051,258971,912883,1015127,797239,650162,999029,142993,302308,111751,419550,668257,970277,266967,436771,176598,312012,12944,230901,416847,716015,428157,964087,616868,82469,52639,89486,122766,673970,308556,51244,463003,30754,368113,1029423,674115,982744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]