SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338056 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338056 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899104,749597,85632,592179,502953,688502,806191,681803,646314,50309,455558,714609,479901,841931,346616,1016323,460094,577925,348360,1021605,303454,681786,884900,864041,537702,715826,478568,1025354,401373,850629,854200,107978,904381,125728,893848,94630,273597,551704,445447,728426,455196,594178,686167,684805,1003575,476900,459913,1036240,744326,951135,384186,720058,959635,588271,788083,931349,326363,409019,17078,950996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001222s ]