SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 165912 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 165912 [ RunTime:0.003090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401868,447532,190789,442270,596255,361583,635918,351312,361038,1014323,814182,86882,13491,946163,225184,244226,85476,97220,991493,239742,800440,916202,38370,789358,606535,519327,1008863,483090,319530,532061,1015011,11687,957007,586884,809101,440345,640560,287170,211928,506296,922133,136752,604623,766241,1039490,609631,34881,720478,271006,841908,340046,759503,618694,537130,862856,769549,430873,1032323,803305,1028625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 165912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 165912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002915s ]