SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400427 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400427 [ RunTime:0.011274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767215,558435,438994,877410,124063,1035687,44027,391813,1004216,887136,516574,255003,288976,658098,966092,817656,329248,357848,557142,443016,248937,769949,331245,382029,38528,572280,212874,507492,533355,761210,540383,599342,508554,825201,939126,644294,577174,928234,327051,202465,730570,299864,914339,926033,809039,340555,585402,14479,1048767,879852,9576,239217,73204,998667,16380,724183,189413,286167,196902,151000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]