SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539752 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539752 [ RunTime:0.005298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88912,816225,358578,932460,228282,384884,259221,624715,874039,949485,1041657,7458,220296,11074,128355,678747,591474,335688,944412,40926,520605,855005,995759,639299,975177,59796,449135,67612,160487,93099,197559,435343,72633,700956,736247,487798,262869,302519,502415,454870,1037094,180756,455170,473032,375019,978795,945873,546332,517922,951213,577711,75985,437243,139931,827329,269531,231873,459901,152113,455337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]