SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045467 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045467 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130356,467539,981880,886363,782192,394808,389967,765553,868076,28719,108819,24703,123340,441012,390610,413765,957898,192953,56350,826273,66807,430310,339892,547611,874576,463135,516971,182980,231835,250986,1004149,871008,785269,32240,220722,314321,978212,472842,91670,332975,145733,923149,145451,213653,424439,977223,1039581,318383,427780,252596,894290,634900,224151,800107,337344,381026,229055,102131,39559,965130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045467 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045467 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]