SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462003 LIMIT 1 [ RunTime:0.003120s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462003 [ RunTime:0.004352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502973,948690,927451,301792,875392,451084,847073,558117,561406,67140,414218,517414,344220,225856,838288,247816,701791,119550,850138,21147,126880,479173,541937,189182,299446,39253,855833,773621,1016338,729310,784210,756845,1007557,911147,258537,660171,601382,280988,930166,949456,321521,841191,1045061,743687,323753,596632,135160,525081,810433,215371,23462,484558,444928,523493,145281,1032221,66138,108331,256409,472093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004083s ]