SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438088 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438088 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584781,263002,469536,668177,66679,911678,188337,868113,348673,142251,107531,635823,361436,71987,613980,3305,815869,683226,381026,684288,392165,568526,996971,1021011,492329,708126,367851,769257,426128,863612,533452,1042580,384163,799386,854483,1015699,345396,211485,822091,447889,569265,768495,956743,147947,815696,428890,181712,989516,757196,482546,143733,1025634,552215,282141,278470,957267,795391,311091,595419,409887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002221s ]