SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449483 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449483 [ RunTime:0.004100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317262,231283,939840,410097,955752,388187,171137,268547,439220,602151,555085,850550,145718,727568,274561,1004418,286683,829260,568554,571087,844985,409246,380329,436875,287168,805564,352639,970947,859177,725222,698849,865614,294003,609801,527675,524006,36204,304677,780221,903339,992121,669707,123817,430253,401961,743464,634231,166091,874910,1043882,238680,362298,530185,649782,701651,761747,414088,326349,814547,282508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]