SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011822 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011822 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499003,58218,15920,427240,417351,414304,568918,440339,771332,426913,402953,741441,447911,131463,117508,419381,626790,917213,516118,255627,877770,641791,163714,305959,281472,221126,952073,816147,107921,44048,693436,819370,655124,386190,670562,103254,228139,521669,218306,35803,331201,657586,449881,319109,54462,877993,1035877,153953,410207,201988,914823,733916,861546,147628,180315,473278,1040990,108745,198617,955012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]