SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414927 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414927 [ RunTime:0.002228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754088,715537,384359,304559,872591,955919,589907,767634,149557,1039693,232500,104055,166562,257720,434169,618457,651509,855642,30681,301757,931765,109708,421983,1004014,513645,791982,394200,613018,298779,1032970,160418,829840,401016,784184,673312,549447,898373,140194,982850,957337,607104,327791,435851,498633,368685,225770,138357,976853,958006,396537,956660,52123,76986,378072,635370,639929,718915,453842,916531,705775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]