SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026567 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026567 [ RunTime:0.003087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551557,802704,881561,295956,235986,107449,292172,102678,366807,20696,938831,891689,813194,498266,127890,664443,807578,598294,449002,107103,798570,754983,979510,525249,63480,233926,241122,966316,206223,423677,800293,12605,436885,132739,114923,36135,625160,357730,947208,260640,945045,13462,53369,454562,798951,259175,564377,328094,549190,120498,750378,685528,80921,378781,531709,538665,390036,225433,724827,780806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]