SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 924091 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 924091 [ RunTime:0.003344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252897,123113,535290,50119,503486,473073,382147,880866,18581,631180,141824,853375,210044,426667,691107,926000,294617,712595,760050,768757,386740,343108,271036,612288,292805,268066,529345,597476,338359,294120,76356,521349,157944,23583,111407,593626,952164,943978,784543,975319,120480,903410,355337,848745,789489,967664,193209,188602,481720,698472,916657,360823,684490,451768,344811,661288,743814,906715,11454,149316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 924091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 924091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]