SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509291 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509291 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000530,667462,798635,348983,798832,446850,920191,511712,535292,182844,906207,487185,98243,585808,824734,497950,689953,492632,106560,631328,511813,958728,196719,974941,453712,849793,1002950,81212,111822,464504,231509,43018,89116,35803,1028576,709357,435268,823224,237101,447459,393072,490627,351647,92184,10718,246356,161170,956529,718885,645591,53430,623461,717859,436362,817747,754626,523279,58375,205945,877760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]