SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961012 LIMIT 1 [ RunTime:0.000608s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961012 [ RunTime:0.003311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201153,911153,956781,333204,512583,461866,788208,367898,672677,671036,431944,336334,242087,739097,296277,622448,655605,568706,184363,664689,706239,1000033,661304,384489,407289,620328,755390,146973,1013744,835926,34675,208224,120953,78666,646217,791648,18525,80089,570931,579655,473995,580142,863531,358217,55350,692957,10614,351256,217330,769311,739518,773224,638202,182001,1026622,675418,203144,667165,76887,872138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001554s ]