SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472354 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472354 [ RunTime:0.003668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686176,981955,1021503,460956,18829,167984,99524,570118,877916,972100,294417,751799,889531,740557,257114,20322,726953,257713,266287,586644,482548,214930,639073,445817,461592,699675,474914,71923,987505,903437,1002066,207051,598174,163785,340987,675694,662737,599814,618612,608869,767649,467942,796038,534818,170907,308027,34374,1033885,525628,572945,921926,110185,188145,870686,65300,845802,155769,816358,321721,334851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]