SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040770 LIMIT 1 [ RunTime:0.002462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040770 [ RunTime:0.003283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280059,430816,735288,492559,506295,384002,817239,257161,75868,727493,1024372,329827,38672,1019911,434040,888127,167023,598713,196862,180676,50768,370172,600304,144721,666345,282855,810296,843570,399490,829226,156032,886437,279466,220728,198564,1032126,151480,12438,684898,829670,876188,952669,189196,938488,910271,337699,912910,668025,360929,493523,506564,582802,643661,354924,361680,583889,854667,845750,158271,635599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]