SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034050 LIMIT 1 [ RunTime:0.002439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034050 [ RunTime:0.003958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812645,390391,879645,882712,369809,684820,74021,515317,703631,391101,301254,844430,785051,541212,994716,467313,791175,172455,525602,661858,336096,794065,947158,560288,147024,334182,68553,757071,537410,540980,110640,804661,777610,101420,370390,447600,220656,188477,995408,284307,56991,639890,775667,218282,798067,17323,423949,441204,473502,921263,678307,278536,7776,509661,71852,1476,683480,677607,450351,1034850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001406s ]