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` = 502245 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502245 [ RunTime:0.004360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812347,725872,628057,582938,589014,1017951,823708,786516,502879,996571,563623,718473,18149,787776,528571,263474,844445,416264,248032,937179,580466,110044,377937,194602,49668,128006,229805,962811,624310,445662,687781,739136,289403,662567,143228,403575,371660,26484,318003,530651,683133,1047147,949943,826209,824459,3215,162789,967051,376364,827169,1035299,447601,148331,728550,402456,760460,944660,448331,467330,626828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]