SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047635 LIMIT 1 [ RunTime:0.001688s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047635 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146011,101394,466278,591192,54511,75634,738363,237845,724181,863760,789088,77590,923104,429952,77713,102887,850069,326555,74728,916429,123387,849689,469854,435140,557632,227803,965274,675517,80693,604046,500222,40306,835392,789260,70973,936344,926846,928779,885406,644460,816498,936545,887238,209740,950877,29481,291321,938205,881591,1040801,963846,358194,723080,329213,1010539,523999,501187,186558,580792,528076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047635 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047635 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]