SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417060 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417060 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159792,740406,745267,749202,624548,447333,680481,330624,5258,523618,322709,291515,308917,2503,922614,603067,879302,674052,866727,717786,348240,12187,309783,287245,473157,865759,691474,594947,753352,869220,569261,263418,423255,772348,603186,435254,915888,575879,270343,860611,722540,290431,167998,568173,374496,296408,536684,170780,698811,151342,478407,203964,100341,793599,38348,459113,671299,995379,7225,66168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]