SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027808 LIMIT 1 [ RunTime:0.001296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027808 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041003,79264,333413,309290,227569,1021167,693144,595874,288696,634540,280906,106296,210141,1022366,315763,655283,539637,378349,353966,160425,785632,690791,614745,184578,852470,63409,333174,911017,369062,94873,409041,606056,637260,146890,1013849,209601,1013640,43833,618000,439114,792672,662325,175924,982679,311889,962544,660455,227945,492223,827983,294652,353693,726663,618386,68422,476720,942683,342429,452161,638922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]