SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479243 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479243 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769097,181201,625612,258438,950127,588452,1038648,28649,495628,819492,6506,758812,443723,345217,453339,326435,426089,667828,634788,309415,134198,86899,172713,584306,449466,58301,1007623,656983,125139,879686,98143,89416,909439,592823,718844,427336,415029,66990,651696,916703,281433,394749,412615,421250,140637,655672,645433,224274,248638,100840,868368,330365,102375,659732,150264,265889,1030084,883242,680141,863978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]