SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014670 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014670 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71739,806659,909240,391832,102060,833858,346957,124883,446024,577661,522605,960840,195420,613659,863357,671019,48885,297420,1042445,350596,536461,891081,238185,779777,404558,982013,186916,734751,616883,560017,261568,398568,507390,49689,149420,356892,127703,620365,232740,658561,216105,86378,19432,605087,286423,627535,676163,736804,448433,614304,487532,129196,553221,934727,47095,340395,847210,992644,972465,69218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]