SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416709 LIMIT 1 [ RunTime:0.001387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416709 [ RunTime:0.005353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532725,486280,1003054,296317,659791,651033,174006,854258,985862,292063,358406,75523,697464,658429,699633,725705,602178,709679,512273,378118,371908,651,419906,130151,1015442,1007409,101452,24202,216201,316212,8945,624996,1044135,14725,989061,313423,312458,18686,976102,798475,762692,104024,866022,209934,817258,383757,179585,204028,823601,315280,948668,56433,129195,482040,33133,778511,349513,795686,253202,423535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]