SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557221 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557221 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310307,687820,904479,587262,828603,964677,671756,273771,222987,710061,260982,176291,464051,538654,224722,750078,449366,781892,613356,887919,800339,982378,627597,14117,246576,259597,163113,505531,280690,40268,351125,193410,152732,693249,464115,368364,135118,472100,451344,475680,949029,91397,398609,30352,729822,123393,1015569,194292,226914,586917,280720,364762,72125,882512,950473,431833,159422,828455,221101,516475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]