SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504333 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504333 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474487,534686,615914,686841,385953,653051,741709,279234,982939,164942,381735,693775,167809,402221,168405,446432,232352,564004,196655,865531,393329,18151,857059,198058,679311,608153,452683,338647,949232,596988,702381,1042185,652388,28798,182780,1017854,690824,266792,362328,672393,700232,627915,81984,556347,226103,182268,721028,360042,664832,515022,967501,344137,470886,788998,515963,954238,267628,847777,849317,17580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504333 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504333 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]