SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005987 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005987 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957610,591452,757992,343395,671142,446502,224493,742399,905753,754844,548920,473248,752022,1006901,260984,633843,662426,340024,877137,219947,374573,64533,684419,638403,982472,597549,489571,515332,256409,163030,430405,175979,160013,327925,751377,620835,459339,895981,335595,82143,247275,698416,952452,339103,61349,858901,494801,815942,132023,355861,855478,299921,499524,160679,972117,397505,92370,581020,531046,327991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]