SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039166 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039166 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436951,794899,882103,243809,734239,835530,624657,286127,82520,696014,402685,897716,573524,319597,872291,279294,702997,860979,60910,427017,966488,850093,575657,942779,622259,1025689,442748,949522,1023416,466742,106060,700096,957081,65767,711493,652170,100838,207142,1036650,172692,741523,147755,996726,632782,918883,739903,809722,1034924,338468,424479,806954,66314,774347,842997,204475,210828,20655,948115,304132,31294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]