SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801543 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801543 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364835,27965,283861,41599,773335,977320,928362,618637,123317,131102,283896,2978,499000,1041019,98992,770643,701796,373258,809734,423063,48860,708909,75133,688351,409057,991012,209247,490648,163097,999375,193443,162067,32402,483793,715364,776083,30089,673681,404309,939909,99223,533255,499404,68130,740115,53832,394761,794854,829272,724769,761830,307652,935512,143210,470651,919939,246087,616747,964418,27319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]