SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195541 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195541 [ RunTime:0.003673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348581,176657,444297,146236,119973,658215,1023625,156735,143018,532135,915157,834090,356446,197030,118837,773088,106449,481682,618226,703515,774951,969014,223755,303709,182138,456400,247678,784532,122583,181981,511517,198184,226471,1043362,102273,73710,657381,633120,202855,718912,812729,751477,29288,63585,805918,113091,400503,431399,928041,394278,683258,690247,436068,377133,794495,950927,1017208,468146,220101,371953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]