SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416169 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416169 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343724,270997,603360,178854,961583,706990,392473,101304,527305,59102,301094,429879,959237,478387,499607,184536,595057,808043,856406,291921,680127,1029590,37648,458640,351671,297580,269516,699385,607030,797563,163086,778827,558875,655381,974803,493444,627374,938990,826444,829573,139389,167074,651530,177060,923724,403822,508095,536976,320079,129344,1012675,813670,579603,82854,538745,453069,243060,71336,643300,166603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]