SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509293 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509293 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398011,204461,178529,570821,706041,330867,227093,564073,482892,117427,955927,799600,699093,806591,110715,682844,157256,98275,829184,710030,548152,626006,78694,82297,264698,1034782,754373,316706,635830,722928,749021,207088,875438,961495,833131,953341,443675,685529,963907,999328,68579,888324,424214,213540,810957,152841,253436,114331,851697,44405,644235,579366,684094,195039,961685,333423,546061,989305,525574,350609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]