SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406584 LIMIT 1 [ RunTime:0.001052s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406584 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220093,36057,125235,255458,767516,1026030,718955,250557,756770,1017675,336695,937135,505675,613253,400063,75957,861549,953966,911660,678308,282506,560251,96797,836129,697235,925031,586649,535448,742744,1042928,488203,996861,897658,837351,180945,770421,535423,985796,411139,661795,930587,184333,859496,127177,49409,955611,43785,706608,567100,579139,812873,217360,90833,169827,434058,1001583,737162,1034785,504740,358405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]