SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319029 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319029 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293560,545288,190367,248792,718619,309265,17411,342879,3833,190140,681496,237665,605647,943385,933425,490541,268337,1007375,73374,15608,387730,109913,662525,734077,694001,1012998,306135,1045435,517291,5858,190743,573671,500040,540459,102423,289787,329444,514703,101012,467480,162531,500763,864860,934225,21553,964289,752061,355630,82829,1011589,831856,491796,559606,122103,424907,978673,427509,1022194,1032307,154589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]