SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49584 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49584 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404013,373623,259744,1008632,990164,194007,341442,963480,291310,259940,887698,288128,293596,47143,677202,251835,834487,673408,492071,654015,364482,959203,32228,414741,604155,768517,683199,582025,339651,458164,497378,617025,901609,623616,284163,633417,780284,625785,860341,465102,411904,363097,459891,463041,872461,1043643,293036,409599,354839,168437,260948,657465,1024787,153310,991013,785019,390201,114259,410606,104735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]