SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003915s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520267 LIMIT 1 [ RunTime:0.001321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520267 [ RunTime:0.006019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580973,74839,6846,625922,595149,537653,1018688,100872,810698,811685,1004300,470054,912454,838311,754764,458941,685888,381536,741357,346133,605459,31649,72830,558377,987019,62557,401334,391930,154378,171595,1034830,971488,425720,976386,854275,885224,218482,661332,366247,776992,154788,118175,317813,550790,610340,238282,649587,1033393,740742,922931,273692,296391,330503,342482,423461,214996,744719,919863,37009,897610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002292s ]