SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201392 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201392 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997177,10694,650249,677199,812744,1004086,682335,640251,10770,682178,295141,926190,289600,611729,29730,63592,325850,913627,982148,588311,249329,357577,634907,681815,458119,220092,65286,672079,646699,402308,166696,536948,199678,472191,654230,498275,954119,884127,760946,930745,336361,1013114,130238,689135,976028,110978,371655,724782,296235,56668,298697,601466,992741,939267,296742,907308,779974,247703,110893,837673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]