SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980962 LIMIT 1 [ RunTime:0.001339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980962 [ RunTime:0.002718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598814,178788,890192,105373,879479,505632,947241,370999,564592,207930,982614,372498,571722,1032373,288551,422544,950451,837838,517229,470769,226996,100496,735456,612777,221926,748291,401574,556537,872127,31899,424100,350088,590450,913327,955129,275987,26640,68404,194809,588718,850062,656991,699819,226064,146153,902003,4328,90915,113023,311836,351694,1028160,174302,493977,474392,1040800,237025,305430,898538,420233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]