SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534347 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534347 [ RunTime:0.002735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515033,661860,120152,265842,848787,767261,232147,574103,371787,836679,599640,86842,625764,138708,48899,338505,63358,40914,889111,557866,723401,659359,1030096,858336,169677,949763,500600,300802,496759,353929,68880,307378,441658,920507,913561,262120,142956,864724,546406,592205,817452,573486,250985,553227,206850,1003214,806096,181354,110897,669983,576292,88219,220830,826129,760004,929999,280060,770189,6135,573675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534347 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534347 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]