SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104411 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104411 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822354,828217,837575,327714,655628,923370,97419,862233,546271,748056,982055,432810,551448,14753,105435,212831,637938,857115,865494,345624,140918,793602,451086,886100,630166,431805,54014,221200,808378,784472,38414,245439,188589,947236,875848,355557,1014083,1029441,525023,856129,268556,414247,913679,13701,86159,693264,730177,88550,1018174,74445,497763,787841,170228,458814,84578,859525,339843,978014,757690,792947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]