SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333801 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333801 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043659,136221,821457,818687,667295,58847,152002,121420,137113,806342,822729,235286,450335,720115,201268,804718,202931,55576,280137,200118,165845,667081,22368,484148,870420,112553,472463,669073,822641,960821,27116,963196,12792,1028291,399490,2511,226001,1045233,748524,454478,232568,780080,421216,585047,994556,771087,956277,671375,915684,146674,176414,521326,474532,444862,1025162,1036937,662905,986857,533706,784312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001442s ]