SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593806 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593806 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401118,862144,352262,700185,850477,928107,128521,397999,780558,553473,221585,841380,472232,369079,650137,154975,84217,2055,616257,83028,141729,118520,414965,207965,186091,180460,401129,132293,349311,235763,747514,887148,901823,947894,13615,763082,310838,542824,517354,775207,199515,645666,489148,184710,792610,538139,718253,286350,604882,605124,434525,359819,614331,520951,984779,324236,657879,644773,62206,899156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]