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` = 467067 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467067 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346389,701628,586202,550948,371932,567581,567884,230163,717483,923560,276138,245337,794578,6751,28267,731472,678545,515145,649804,140162,1000104,291427,697852,14703,159165,830215,495994,363582,968736,144391,681846,539693,1024804,463300,921593,660443,722554,477743,404280,196365,456712,13249,484460,934556,264347,1001418,943935,266228,608647,147826,928751,779052,355138,598522,113874,548396,306266,22604,858971,239252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]