SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001914s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008101 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008101 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347815,365720,761842,795839,387498,73858,168528,790858,767370,194525,811161,12740,224901,571799,121330,1030556,331680,961683,21031,218936,675325,758832,1031070,348139,884604,883543,554107,399066,602564,503036,757906,645917,805713,267162,715381,845342,235042,1017780,109123,505400,982829,30266,64373,209628,885847,512825,293418,806182,851194,439573,68786,346305,286444,615748,588879,978660,575143,58882,775226,501904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]