SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025204 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025204 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830109,735025,775981,774770,362955,209054,609167,926398,461146,1043129,551379,288941,333379,952185,841122,449712,54518,705054,327810,108359,815490,788843,852533,801413,809569,469861,419902,324159,574741,882872,103525,447342,983464,985219,928221,359552,987942,542819,449505,230827,184656,59,812531,522651,794917,142631,71908,69210,387571,547993,305564,507840,338286,772086,60101,170142,772237,365991,919125,3722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]