SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470946 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470946 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111900,434732,770032,115608,991873,248228,672905,301120,488624,1028855,435122,212896,657093,68604,57976,348581,785970,1028712,407128,607288,83230,939936,200338,88119,132963,171085,120383,38745,331046,69589,271977,951188,995709,102955,611634,9167,769846,674652,991769,271420,454969,651712,541887,358000,416314,743507,122899,720103,75910,839688,722930,939188,285268,448106,710254,770908,397751,203689,848102,36423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002843s ]