SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331528 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331528 [ RunTime:0.005404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164408,142631,611752,211099,331721,984667,548738,827720,234513,321597,953322,132293,926680,654102,438157,266676,554655,254288,92229,709404,572377,914768,345187,704122,738805,901683,163310,165126,405770,936693,559112,418392,340157,235672,1014742,153838,215306,300921,777990,680265,416249,658108,931767,179457,358834,597788,687671,607104,1035372,235326,497703,284344,923338,112020,760745,659600,239977,207251,765530,651628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]