SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 939460 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 939460 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546331,649361,569139,499073,863842,720971,894427,282764,486590,289817,232795,258043,380638,452595,1010612,858652,783907,184737,638341,882007,176107,194583,251420,106838,373040,29960,289583,811778,1011434,304339,282294,899581,573403,41885,338876,353386,486834,848526,1006856,804453,789025,14298,752647,301558,86686,926279,453907,306493,972345,392012,34220,639235,495506,70601,974359,505631,1035450,61197,340636,792991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 939460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 939460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]