SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335569 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335569 [ RunTime:0.002127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905288,155630,502127,505342,468096,327242,916921,1011840,174909,413857,665003,344223,402531,449957,985752,192390,118445,391060,731431,200440,87952,191510,998505,835259,750781,290861,998098,445971,873052,702484,341932,31386,675467,563334,316676,776999,449940,236730,460207,316170,893170,361062,660037,561801,982685,442011,584643,100869,444098,578583,115106,252787,5142,373179,656673,746470,963626,806070,790833,10549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002631s ]