SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469051 LIMIT 1 [ RunTime:0.002776s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469051 [ RunTime:0.002389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234064,737668,938886,755909,996671,709588,975476,339506,938943,103663,629904,159612,285426,188060,1044589,105893,21755,660837,35469,504313,414604,825119,315103,584280,269087,419301,936266,260964,369802,673232,432487,546081,562606,149894,102503,198786,105542,401341,147287,173623,869334,1033092,1013749,249718,980046,659424,496058,584769,1020540,334173,555065,302417,73517,791012,325012,175317,856991,130116,730614,156606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002933s ]