SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591983 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591983 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658143,663370,592947,602245,546084,33726,363812,44014,225150,554859,723697,840750,888737,50474,602015,801286,770374,40691,431616,387113,732980,776589,65172,530136,782000,366907,202048,631324,820216,59319,702834,874705,388175,1010491,498367,394414,416424,182117,188094,400132,975069,75161,361371,428547,308000,356833,25856,527185,65741,326852,612789,283244,933632,903499,964762,584354,181608,139497,626821,583474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]