SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455803 LIMIT 1 [ RunTime:0.001481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455803 [ RunTime:0.003529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276205,149354,788161,876592,885118,302894,1015395,229408,654959,116272,1017681,111892,92008,959726,641031,808864,91544,155159,34928,239632,465744,118785,774577,366168,394430,274145,758328,665764,753663,779083,113311,380525,700215,304257,852379,21138,276907,540899,175443,268543,327065,328638,520262,659280,948963,275000,209833,956359,718367,156063,1024312,284081,729933,646184,481428,30025,75736,771300,932560,142747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]