SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109515 LIMIT 1 [ RunTime:0.000672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109515 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665711,119642,379321,561050,893823,496542,770156,970151,1018769,45562,643832,416995,486124,797521,267893,306671,131430,258990,817723,4590,1040912,365177,708408,174244,90804,959419,407736,204754,669198,719129,155237,164920,937172,852860,77428,395659,586515,908278,145895,679858,249850,104051,401347,869476,24632,189307,232998,680090,660106,653602,194266,268797,226942,66473,44751,597734,578127,411562,346188,305899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]