SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564610 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564610 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155309,316571,37587,245289,110109,541798,136438,451403,779825,742025,425824,285014,80680,477999,541566,167478,568421,433618,659777,650761,709431,322697,801288,1025554,215920,500764,224310,364994,655526,450781,82348,869046,583949,658254,201788,780723,152428,742600,1883,9225,942055,441557,49848,621602,196280,975143,918892,725013,152674,127714,789371,186118,13745,276410,723320,532515,554065,459212,28688,1038475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]