SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003861s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44890 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44890 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885270,150050,994555,530085,251719,760268,683348,1012557,777513,761406,624769,39247,521207,856128,825272,731040,739976,160263,903253,988739,455835,1000994,710160,990658,501025,721172,883306,1021252,559378,159776,1045609,648489,750846,847433,357115,546526,552911,372624,356859,324476,549280,6877,286325,581189,1033647,399783,236793,284955,835616,985683,651653,521042,733172,996333,790673,375169,312092,19074,165144,201133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]