SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984499 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984499 [ RunTime:0.002897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899797,1011040,311239,178481,1026237,627979,713329,361968,123691,887136,521172,161151,5001,422867,50215,367807,502790,319429,210951,939923,807416,770945,1040787,680024,1009818,584746,9799,846841,288969,193815,19798,233909,603236,377839,410923,55262,637782,500134,614620,10072,416183,770650,432653,335213,202097,114616,364439,179613,767561,95519,108213,698159,111149,411753,148753,430780,438348,623424,791688,35139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]