SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481516 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481516 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13691,558910,124912,637608,766212,20841,840742,351684,383455,737939,84844,722066,564487,587915,21296,260775,440264,264137,887147,1020943,842758,1042877,68994,395970,231191,385913,107075,770944,48365,952115,825894,859317,750954,717009,3839,665356,182633,920710,841228,103369,1001176,789382,152477,490906,906373,790935,34566,950130,404581,573700,659820,639791,824461,594189,358325,329847,117653,767002,66977,625971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]