SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294090 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294090 [ RunTime:0.001377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572273,251931,356584,187511,110553,851247,7589,404109,601400,611722,115690,645244,600755,69551,592262,344216,419616,658231,831099,329438,440944,65930,710950,481045,662463,933248,115209,771577,315942,324641,1447,778060,370297,1009092,428409,671028,125363,639340,538979,689218,65326,913253,877989,659820,442793,902319,498092,339640,314238,329309,440942,511313,929795,341411,124361,752666,854934,293580,762448,263468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000794s ]