SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109284 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109284 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480997,789184,12614,997543,146962,648980,149706,1001324,713768,979059,797219,1007730,949308,482754,234202,1048659,394031,93088,200599,323304,1013433,76729,74079,889840,956555,855793,19227,285742,799342,110047,101286,836530,211594,379786,328482,1033259,665143,171901,929743,301654,366630,715463,1001417,966725,675593,449088,365871,463788,805103,543119,749377,433415,155716,704945,717668,53993,210974,12525,566906,416723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004344s ]