SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004171 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004171 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979968,345513,178062,838609,21213,12423,55367,160406,169270,623970,597471,76137,780148,739448,259129,618348,225375,697797,841691,104794,18374,987311,218112,106829,900596,442008,650014,469326,937514,535910,754118,772069,942365,1026674,9815,368470,231435,445454,409190,770565,352754,282528,702791,38521,270901,646056,176175,208232,1011491,1041651,1042519,1035177,525138,281591,886844,6046,451808,452295,894322,75709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]