SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419516 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419516 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134367,837234,518980,396385,424130,1012651,1009886,60026,218718,818802,1041667,780616,633111,130200,1040690,716922,466784,496756,498802,52154,690382,564249,97390,467593,301373,965624,204230,487683,948591,191568,527771,872343,851361,723044,24391,349525,230734,729815,727625,989743,183152,489739,860684,635963,909343,681433,148459,1041498,266761,635691,228389,272740,836864,428371,789906,106472,1034189,477410,77121,68886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]