SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449896 LIMIT 1 [ RunTime:0.000685s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449896 [ RunTime:0.003606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222979,210797,257662,399853,1030490,835897,346809,448051,293865,271857,602877,184479,55948,780832,888727,1000591,442655,1039966,107303,936962,958905,979447,134136,197619,384805,347357,289479,263146,631557,452399,385902,292177,501937,615762,886881,113646,316270,58964,789147,772620,571032,688693,942381,543926,47187,176314,895342,690312,935284,734866,166384,502898,87632,409316,380167,487593,688850,727285,205491,476228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]