SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39164 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39164 [ RunTime:0.004065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620320,992764,805173,472709,758816,508243,351372,334015,12412,83613,555467,1006138,681214,564898,165693,1001190,116842,256461,51500,9742,585653,929994,505977,396501,145413,295180,50813,387541,368654,49280,803840,626,692792,742308,371217,40485,807513,844805,952634,13179,543095,230739,164661,756950,531182,812360,37199,413602,893904,129584,496636,110309,849731,58430,516689,261016,439808,384602,340355,946090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]