SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314409 LIMIT 1 [ RunTime:0.000848s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314409 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743413,958780,307731,24788,445331,712886,198287,895503,123970,902562,224568,2032,885562,1032275,765676,616860,709300,563526,900158,3767,799838,369532,998858,234540,1025150,233737,232299,1017378,193957,564124,125441,638478,456023,113073,861750,711343,573514,263201,653249,315838,415326,917470,467742,213011,92799,472857,5828,435605,1026735,453423,91904,293261,837448,153248,566191,242948,193092,746421,279052,545703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]