SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348299 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348299 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134407,131565,1008990,303545,145654,327063,386295,451719,46430,280600,883315,649438,955390,967373,991020,898288,99082,769459,648180,470771,1041484,614105,546904,370637,589730,133520,376099,458294,1044674,783235,628809,512488,713405,624381,41212,201868,637134,271238,32687,477034,587742,449688,112854,653361,654068,646453,376770,525994,697871,405082,399089,968192,1003342,333674,143642,425521,1039176,798251,990243,414079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002953s ]