SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556412 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556412 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977880,412129,658125,233147,673245,943073,922499,260218,740891,783786,95021,281348,763624,636572,462353,999690,298147,1003498,156925,492312,163488,827371,854763,1035580,471261,521157,476121,686804,514238,362522,357400,125042,890276,659239,48489,177470,537111,783947,516603,119164,813768,500011,553676,81444,22430,995997,481083,539203,896911,443758,656726,376021,329925,176401,779811,399810,122083,215386,47567,347341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001960s ]