SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002965s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472813 LIMIT 1 [ RunTime:0.001675s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472813 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457374,295103,52549,25329,670006,741771,262836,997863,333408,808453,184450,90063,45401,682651,54797,331004,854249,136632,1040702,700476,874565,126674,188270,740032,24824,162520,841831,828649,338109,902453,174389,487477,1036948,161607,392081,105675,400484,622432,126199,754918,778492,45740,269992,164734,997008,84599,598082,348967,60877,97981,397821,865514,396599,443882,244218,828365,123276,353812,917980,26600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]