SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427366 LIMIT 1 [ RunTime:0.000778s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427366 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602840,938641,412451,631483,529502,47835,338236,568118,405635,93515,331684,600924,375558,318962,161569,395676,888667,136637,501942,665754,1027304,646591,812216,817328,668901,492370,834740,959556,833083,343918,221955,676911,443594,978381,795637,60790,156514,406647,631979,745527,179117,449322,265777,814995,844882,989955,163667,452207,443988,214998,771711,1041856,455921,515062,564483,566838,95769,196411,1027334,361066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001074s ]