SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39343 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39343 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414541,646100,939300,650519,250248,904930,78809,54543,860432,921213,640034,1042588,865760,676321,5989,393267,69389,222141,592604,944235,269712,191989,841535,1000537,238101,753059,541869,443118,801100,1043369,579441,43124,330517,72765,774997,170952,742399,607262,733685,120577,662156,17294,521586,517467,868314,426049,818000,422722,722490,499288,244118,936023,530458,127927,720625,736638,488472,485520,359284,817966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]