SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538011 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538011 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524926,720289,889502,700610,1000576,727250,366164,670758,98482,594588,9138,207523,540949,205317,830246,417148,977834,685409,729905,327966,271951,333700,145707,683370,390772,98029,361801,700634,378241,265455,180990,702768,429327,850814,772134,180856,596285,10842,482930,711075,759351,909048,663415,329955,1045443,922335,711576,495489,865224,142376,408996,482878,285782,17802,371924,1041130,794205,951167,919802,542649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001833s ]