SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394948 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394948 [ RunTime:0.004555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324613,718824,875811,543752,125865,345458,553137,522800,254951,521106,514637,393042,52711,161332,9086,607082,616921,119267,898071,396450,896414,685842,256468,734740,718648,948797,963482,165653,900722,498120,1016490,326395,1020658,655328,921911,427927,291320,556300,114891,692432,389260,426710,293923,286170,568718,1031617,193849,244495,945555,825691,453498,1015370,993312,90804,388640,184937,427372,718139,91951,689211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]